Database Management System

IMPORTANT

Database Management System: Overview

This topic covers concepts, such as DBMS, and Computer and Network Security.

Important Questions on Database Management System

HARD
IMPORTANT

Booth algorithm for integer multiplication gives worst performance, when the multiplier pattern is

EASY
IMPORTANT

The database schema is written in _____ language.

EASY
IMPORTANT

SELECT * FROM employee WHERE dept_name = “Comp Sci”;
There is an error in the given SQL. Identify the error.

EASY
IMPORTANT

In the referencing relation which of the following integrity constraint requires that the values appearing in specified attributes of any tuple also appear in specified attributes of at least one tuple in the referenced relation.

EASY
IMPORTANT

What will happen if in a C program you assign a value to an array element whose subscript exceeds the size of array?

MEDIUM
IMPORTANT

Nowadays Vishing has become a criminal practice of using social engineering over which of the following?

EASY
IMPORTANT

Which of the following in a table represents a relationship among a set of values ?

EASY
IMPORTANT

To establish limitation on allowable property values, and specifying a set of predefined, acceptable options which may be assigned to a property are examples of _____

EASY
IMPORTANT

Which of the following is not a logical database structure?

EASY
IMPORTANT

Consider the employee work-team example, and assume that certain employees participate in more than one work team. The generalization is called as _______ if a given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. 

EASY
IMPORTANT

The database management system is intended to _______.

EASY
IMPORTANT

Functional Dependencies are a type of constraint which is based on the _____.

EASY
IMPORTANT

Which of the following ways to Relationships are identified from the word statement of a problem?

EASY
IMPORTANT

Processing step (operation or action) in flowchart is represented by _____.

HARD
IMPORTANT

Which of the following is not a feature of tree?

HARD
IMPORTANT

Which access control mechanism does security label fit into?

MEDIUM
IMPORTANT

In the following pairs of OSI protocol layer/sub-layer and its functionality, the INCORRECT pair is

MEDIUM
IMPORTANT

A pilot can fly three types of planes and a plane can be piloted by any qualified pilot. the pilot plane type relationship is;